<?php
require_once dirname(__FILE__) . '/../includes/common.inc.php';
require_once dirname(__FILE__) . '/../includes/pdoorm.inc.php';

header('Content-Type: text/plain');

$sql="
CREATE TABLE `ns_v1customer` (
  `e_oid` int(12) NOT NULL AUTO_INCREMENT,
  `trackId` varchar(64) DEFAULT NULL,
  `createdDate` int(16) DEFAULT NULL,
  `bridename` varchar(64) DEFAULT NULL,
  `brideaddrLn1` varchar(256) DEFAULT NULL,
  `brideaddrLn2` varchar(256) DEFAULT NULL,
  `bridephone` varchar(64) DEFAULT NULL,
  `bridemobile` varchar(128) DEFAULT NULL,
  `brideemail` varchar(128) DEFAULT NULL,  
  `groomname` varchar(64) DEFAULT NULL,
  `groomaddrLn1` varchar(256) DEFAULT NULL,
  `groomaddrLn2` varchar(256) DEFAULT NULL,
  `groomphone` varchar(64) DEFAULT NULL,
  `groommobile` varchar(128) DEFAULT NULL,
  `groomemail` varchar(128) DEFAULT NULL,  
  `note` varchar(4096) DEFAULT NULL,
  `ceremony` varchar(64) DEFAULT NULL,
  `culture` varchar(64) DEFAULT NULL,
  `culture2` varchar(64) DEFAULT NULL,
  `reception` varchar(64) DEFAULT NULL,
  `source` varchar(64) DEFAULT NULL,
  `userAccount` varchar(64) DEFAULT NULL,
  `cancelled` tinyint(1) DEFAULT '0',
  `reminderNote` varchar(1024) NOT NULL,
  `cancelledDate` int(16) NOT NULL,
  `cancelledOperator` varchar(64) NOT NULL,
  `cancelledMessage` varchar(512) NOT NULL,
  `admAppr` tinyint(1) NOT NULL DEFAULT '0',
  `is_ecn` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`e_oid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
";

sql_execute($sql);
